Importing Non-Standard or Third Party Courses

The Course Wizard is the preferred method for uploading new courses. To access it, go to Resources > Course Import Wizard in the Administrator's Console or click on the Add or Update a New Course icon in the Administrator home page.

The Course Import Template

The course import template must be used when creating new 3^rd party courses or other non-eLearning courses. The template is also useful for uploading courses (both eLearning and non-eLearning) that are needed only for historical purposes.

Column	Header	Description
A	Course Name	Required Title of the course. Character limit: max. of 255
B	Course ID	Optional Internal Course ID. If one is not entered, the LMS will automatically assign a Course ID that can be changed at a later date if necessary. This corresponds to the Course #/Reference # field in Maintain Learning Resources. Character limit: max of 50.
C	Short Description	Optional Shown on the Course Catalog overview screen. Character limit: max of 450. This field cannot contain a line break (this will “break” the import.) To import a line break, use the “\|” (Pipe) character to indicate where the lines should break.
D	Long Description	Required Shown on the Course Catalog overview screen. Character limit: max of 8000. This field cannot contain a line break (this will “break” the import.) To import a line break, use the “\|” (Pipe) character to indicate where the lines should break.
E	Course Objectives	Optional Character Limit: max of 3000
F	Keywords	Optional Searchable keywords to describe this course Character Limit: max of 800
G	Active	Required Enter "0" for Inactive Enter "1" for Active Enter "2" for Retired
H	Estimated Time	Required Enter the time of the course in minutes
I	Estimated Time (text)	Required Description of the course time Character Limit: max of 255
J	Provider	Required Enter the name of the course provider. Provider name can be entered using text or the Provider ID number.
K	Recommendations	Optional Character Limit: max of 2000
L	System Requirements	Optional Character Lmit: max of 800
M	Media Type	Required Enter the media type. Media type name can be entered using text or the Media ID number.
N	Score Model	Required Enter one of the following values to define when the course should be marked complete: ENTRY = when course is started 80PASS = when 80 percent Score is achieved COMPLETE = when course is finished
O	Course Type	Optional Enter the Course Type ID. Options are: 0 = Learning Resource (this is the default if field is left blank) 1 = Facilitated Training 2 = On-Line Training/ CBT 3 = External Web Based Content 4 = Program Module 5 = Training Plan/ Certificate Program 6 = Fulfilled Item 9 = Content-Assessment 12 = Video-Based Training
P	Launch URL	Optional Enter the launch URL. This is typically only applicable when creating 3^rd party courses.
Q	Audience Description	Optional Text describing the target audience Character Limit: max of 512
R	Price	Optional Enter the participant cost for the course. Cost must be entered in the following format: 1.00
S	Compliance/ Standards Model	Required Enter the compliance model for this course. Options are: 0 = None 1 = Internal/Custom Compliance 2 = AICC-HACCP Compliant Resource 3 = SCORM 1.2/2004 Compliant Resource 4 = TinCan

How to find ID numbers

In the template there are fields for the course provider ID and the media type ID. Both of these ID numbers are different for each and every system, so the easiest way to find these numbers for your system is to create an ad hoc report.

To create this report, go to Data Source: Course Catalog > Learning Resources in the Administrator menu. The columns for the report should include:

The provider IDs can also be found on the Maintain Providers screen, listed under Tools on the Administrator menu.

Importing From the Template

Once the template is complete, follow these steps to upload the courses into your system.

Open Course Import Wizard and select the option, “Load new course/ courses”. On the next screen, select the option “Import Courses from Excel/ Clipboard” and click Next.

If you have created your template in the standard Excel format, select “Tab” (default) as the Separator type.

On the next screen, you will be pasting the data from Excel. If you are going to include the header row, leave the box checked indicating this. If the header row will not be included, uncheck this box.

If any information was entered incorrectly or if required information is missing, the wizard will alert you to this fact. Common Errors include: Incorrect information, missing required information, and data in the wrong format.

If necessary, click the Previous button to return to the previous screen. Make any necessary corrections to the upload and then paste it again. When all of the information on the upload is correct, you will see a confirmation screen.

On the next screen, you can select the appropriate import option based on the data in your course upload. You can choose either “Import New Courses Only” or “Update Existing Courses/Import New Courses.”

If you would like to set the Primary audience for this course using an Audience Template, you can select the template on the next screen and then check the “Link to Template” box. If not, skip the Audience Template section.

The system will confirm the number of courses that you are about to upload. Click Next to complete the upload.

There is a final confirmation screen letting you know that the upload was successful. Click Finish to close the Wizard.

Once the upload is complete, you may want to go to Maintain Learning Resources to set the audience and any other additional information about the course.

Importing Non-Standard or Third Party Courses

The Course Import Template

How to find ID numbers

Importing From the Template

Related Links